Search results

Listed under:  Mathematics  >  Statistics and probability  >  Data representation  >  Spreadsheets
Video

Alyangula Area School – Progress report 1

This video is a summary of a progress report into the implementation of Digital Technologies in the Alyangula Area School.

Text

Classroom ideas F-10: Aboriginal and Torres Strait Islander connections to Digital Technologies

This resource provides examples of ways Aboriginal and Torres Strait Islander Histories and Cultures can be integrated into Digital Technologies. Examples include 'classification and sorting data' and 'designing solutions'.

Text

Digital Technologies resource types and resource mapping template

This three-page document gives suggestions for selecting and organising Digital Technologies resources, including physical equipment, unplugged activities and online links. It includes a simple template that may be helpful in documenting these.

Video

Data knowledge and skills tutorial: part 1 - gathering data

This video demonstrates ways in which data can be manipulated in spreadsheets. It is the first in a series of four.

Text

Australian Curriculum: Digital Technologies: years 7-8

This PDF provides a line of sight from content descriptions to achievement standards in the Digital Technologies subject in the Australian Curriculum.

Text

Planning an action research project to facilitate implementation of Digital Technologies

This document includes ideas for planning and developing action research projects to facilitate implementation of digital technologies.

Video

Expert webinar video: Dr Rebecca Vivian - The CSER Digital Technologies Education Program

Dr Rebecca Vivian provides an overview of the CSER Digital Technologies Education Project from The University of Adelaide. The project includes free professional learning, a digital equipment lending library and a range of resources designed to support teachers in the implementation of the Australian Curriculum: Digital ...

Text

Newsletter – December 2019

This newsletter from the Digital Technologies in Focus project includes information about schools' projects, information for parents and teachers, the Australian Curriculum, and useful resources.

Text

Newsletter – July 2018

This newsletter from the Digital Technologies in Focus project includes information about schools' projects, the Australian Curriculum and useful resources.

Video

Alyangula Area School – Progress report 2

This video is a summary of a progress report into the implementation of Digital Technologies in the Alyangula Area School.

Text

St James Catholic College – PL ecosystem

This document illustrates the network of people and resources that make up St James Catholic College's Professional Learning ecosystem.

Text

Miller & Boix-Mansilla review: Thinking across perspectives and disciplines

This article explores the challenges associated with using knowledge from different domains (and people) to work on a common problem, issue or puzzle. It acknowledges that the differences in how disciplines structure their knowledge raise challenges when working across disciplinary boundaries. The article identifies these ...

Text

Professional learning workshops

This webpage provides details of ten workshops that focus on understanding and implementing the Australian Curriculum: Digital Technologies. The workshops are provided for Digital Technologies in Focus project schools and, where possible, schools not involved in the project.

Text

Visualising climate change lesson

In this lesson, students explore different approaches to data representation, with the aim of engaging audiences with scientific data. They explore local temperature and rainfall datasets over time and represent trends in innovative ways. Students learn about different ways to visually represent climate change, looking ...

Online

Seeing the wood for the trees

In this lesson sequence students summarise data using advanced filtering and grouping techniques, for example pivot tables in spreadsheets and aggregation functions in databases.

Online

A spreadsheet's secret weapon

In this lesson sequence, students learn to use pivot tables which have been described as the most powerful tool within spreadsheets.

Online

Protecting dugongs

The Western Australian Marine Science Institution has been collecting data about dugongs off the coast of the Kimberley in Northern WA. We have been provided with the raw data from its sightings trips. In this project students will learn how dugong sightings are conducted, and develop the data-science skills needed to make ...

Online

Who wants to be a millionaire?

This lesson sequence uses the well-known wheat/rice and chessboard problem as students use spreadsheets to simulate iteration and to solve problems.

Online

Creating my own spreadsheet to convert binary to decimal

A spreadsheet can be used to do calculations quickly using formulas. How can we make a spreadsheet that converts a binary number to a decimal number? This lesson provides some guidance and Excel files for student and teacher use.

Online

COVID 19 Demystified course

At the end of this course, learners should be able to better understand the science and numbers behindCOVID-19 and the SARS-CoV-2 virus that causes it. They should be able to discuss the pandemic with confidence, giving substantiated viewpoints on matters such as public policy with a willingness to accept other viewpoints. ...